Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_9766

R_9766

DictionaryValue

Talon

ServiceCaseID

 

 

R_9767

R_9767

DictionaryValue

Talon

VisitPurposeID

 

 

R_9768

R_9768

DictionaryValue

Talon

VisitPlaceID

 

 

R_9800

R_9800

EpisodePriority

Episode

EpisodePriorityID

 

 

R_9907

R_9907

Contractor

Event

EventContractorID

 

 

R_9936

R_9936

AdmCode

AdmCodeTree

AdmCodeID

 

 

R_9937

R_9937

AdmCode

AdmCodeTree

Adm_AdmCodeID

 

 

R_9990

R_9990

ICD

LPersonICD

ICDID

 

 

R_9991

R_9991

Person

LPersonICD

PersonID

 

 

R_9992

R_9992

DiagnosisKind

LPersonICD

DiagnosisKindID

 

 

R_9993

R_9993

OncologicCard

Patient

MainOncologicCardID

 

 

R_9994

R_9994

OncologicPathStatus

OncologicPathStatusText

OncologicPathStatusID

 

 

R_9995

R_9995

OncologicCardWarning

OncologicCardWarningText

OncologicCardWarningID

 

 

R_9996

R_9996

OncologicPathStatus

OncologicCard

OncologicPathStatusID

 

 

R_9997

R_9997

OncologicCardWarning

OncologicCard

OncologicCardWarningID

 

 

R_10006

R_10006

InsuranceCheckResult

InsuranceCheckResultText

InsuranceCheckResultID

 

 

R_10007

R_10007

InsuranceCheckResult

InsuranceCheckLog

InsuranceCheckResultID

 

 

R_10008

R_10008

InsuranceDocumentType

InsuranceCheckLog

InsuranceDocumentTypeID

 

 

R_10009

R_10009

LPatientInsurer

InsuranceCheckLog

LPatientInsurerID

 

 

R_10010

R_10010

Insurer

InsuranceCheckLog

InsurID

 

 

R_10011

R_10011

Patient

InsuranceCheckLog

PersonID

 

 

R_10047

R_10047

Country

Person

OriginCountryID

 

 

R_10048

R_10048

DictionaryValue

PersonDisabilityLevel

StatusID

 

 

R_10049

R_10049

DictionaryValue

PersonDisabilityLevel

DocumentTypeID

 

 

R_10053

R_10053

Episode

LepisodeCaretaker

episodeId

 

 

R_10054

R_10054

Person

LepisodeCaretaker

personId

 

 

R_10059

R_10059

Person

Patient

BloodIndicationPerson

 

 

R_10060

R_10060

Person

PatientBlood

PersonID

 

 

R_10061

R_10061

Person

PatientBlood

BloodIndicationPerson

 

 

R_10230

R_10230

Episode

PatAdditionalPermission

EpisodeID

 

 

R_10231

R_10231

Event

PatAdditionalPermission

EventID

 

 

R_10232

R_10232

PerfService

PatAdditionalPermission

PerfServiceID

 

 

R_10277

R_10277

Event

OffHoursHealthCare

EventID

 

 

R_10312

R_10312

PerfService

ExtSharedPerfService

PerfServiceID

 

 

R_10313

R_10313

PerfService

ExtSharedPerfService

Per_PerfServiceID

 

 

R_10318

R_10318

PerfService

AnonymityData

PerfServiceID

 

 

R_10513

R_10513

UnitDoseStatus

PerfService

ForUseInFuture

 

 

R_10514

R_10514

UnitDoseStatus

UnitDoseStatusText

UnitDoseStatusID

 

 

R_10535

R_10535

CsiozOidRegistryCategory

CsiozPersonIdOidRegistry

CsiozOidRegistryCategoryID

 

 


1  2